//package com.lab303.powerproject.strategy.repository;
//
//import com.lab303.powerproject.strategy.pojo.Temperature;
//import org.springframework.data.jpa.repository.JpaRepository;
//import org.springframework.data.jpa.repository.Query;
//import org.springframework.data.repository.query.Param;
//
//import java.util.Date;
//import java.util.List;
//
//public interface IndoorTemperatureRepository extends JpaRepository<Temperature, Integer> {
//    @Query(nativeQuery = true, value = "select * from view_indoor_info where CAST(time as DATE)=CAST(:t as DATE)")
//    public List<Temperature> getIndoorTemAndHumByDate(@Param("t") Date date);
//
//    @Query(nativeQuery = true, value = "select * from view_indoor_info where date_format(time, '%Y-%m-%d %H')=date_format(:t, '%Y-%m-%d %H')")
//    public Temperature getIndoorTemAndHumByTime(@Param("t") Date date);
//}
